UserAssignmentReportToXlsController.java

/*******************************************************************************
 * Copyright (c) 2012 Dmitry Tikhomirov.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Public License v3.0
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/gpl.html
 * 
 * Contributors:
 *     Dmitry Tikhomirov - initial API and implementation
 ******************************************************************************/
package org.opensheet.mvc;

import java.util.Date;
import java.util.List;

import org.opensheet.server.dao.StatDAO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import com.extjs.gxt.ui.client.data.BaseModel;


@Controller
@RequestMapping("/userassignmentreporttoxls.htm")
public class UserAssignmentReportToXlsController{

	@Autowired
	private StatDAO statDAO;
	
	@SuppressWarnings("deprecation")
	@RequestMapping(method = RequestMethod.GET)
	protected ModelAndView handleRequestInternal(
			@RequestParam("s_year")  Integer s_year,
			@RequestParam("s_month") Integer s_month,
			@RequestParam("s_day")   Integer s_day,
			@RequestParam("e_year")  Integer e_year,
			@RequestParam("e_month") Integer e_month,
			@RequestParam("e_day")   Integer e_day,
			@RequestParam("branch")  Integer branch,
			@RequestParam("type")    Integer type,
			@RequestParam("assignment")    Integer assignment
			) throws Exception {
		
			Date start =  new Date();
			Date end   =  new Date();
	
			
			start.setYear(s_year);
			start.setMonth(s_month);
			start.setDate(s_day);
			
			end.setYear(e_year);
			end.setMonth(e_month);
			end.setDate(e_day);
		
		
		List<BaseModel> hours = statDAO.getHourReportByUserByPeriodByAssignmentByTypeByBranch(assignment,branch, type, start, end);
		
		
		return new ModelAndView("userassignmentreporttoxlsview","Hours",hours);
	}

}